SKU A: SKUs accumlating up to 80% of analyzing period’s NMV
SKU B: SKUs accumlating up to 95% of analyzing period’s NMV
SKU C: SKUs accumlating up to 100% of analyzing period’s NMV
SKU D: SKU contributing no sales in the analyzing period’s NMV
Active SKUs wihin a period is any SKU which:
Has available stock
Generates sales
Has shrinkage.
New SKUs are SKUs on-boarded within 30 days from the reported date.
Front Margin will be calculated based on the following formular:
\[\begin{eqnarray} FrontMargin &=& \frac{ProductSellingValue - ProductBuyingValue}{ProductSellingValue} \\\\ &=& \frac{\sum{SellingPrice*Qty} - \sum{COGS*Qty}}{\sum{SellingPrice*Qty}} \end{eqnarray}\]
Margins are calculated based on sales and inventory data from 2022-11-01 to 2022-11-29
Margins are calculated based on sales and inventory data from 2022-10-01 to 2022-11-01
Average Daily Sales: \[AverageDailySales = \frac{TotalNMV}{ActiveDays}\]
Out of Stock Rate: \[OOS Rate = \frac{\sum(AverageDailySales*OOSDays)}{\sum(AverageDailySales*ReviewPeriodDays)}\]
Last 7-day shrinkage value
From 2022-11-20 to 2022-11-26
\[\text{SHRINKAGE ABSOLUTE VALUE (VND) BY WAREHOUSE}\]
\[\text{SHRINKAGE PERCENTAGE BY WAREHOUSE}\]
As of 2022-11-29, sub-category FRESH has 824 salable products.
The products within each category are as followed:
For FRESH, the number of SKU per warehouse is as followed:
The SKUs being reviewed in this period are (1) SKUs having available stock, (2) SKUs generating sales and (3) SKUs having shrinkage.
Review period: MidTerm
Review region: NORTH
Review Cate Report: FRESH
From: 2022-10-30
To: 2022-11-29
As of 2022-11-29, sub-category FRESH has 824 salable products.
Total SKU Active in this period: 261
There are 44 products contribute to 80% of this period’s NMV.
Top 10 SKU with the best NMV contributions are as followed:
Top 100 Keywords - Total Tiki/Affiliated Channel Directed from all sources
Top 100 Keywords - Ngon Hub Only from TikiNgon page
For more information, please review the file raw_data_FRESH_NORTH.xlsx in the shared folder. Thank you!